package com.cike.productmanager.DBHelper;

import android.net.Uri;

public class TablesColumns {

	public static final String AUTHORITY = "CIKE";
	public static final String TAG = "TablesColumns";
	public static final int TYPE_USER_LEVEL = 3;
	
	
	public static class DataConstants{
		public static final String ACTIVITY = "";
	}
	
	//
	public static final Uri CONTENT_DISPLAY_GUIDE = Uri.parse("");
	public static final Uri CONTENT_IMAGE_GUIDE = Uri.parse("");
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface UserColumns{
		public static final String ID = "_id";

		public static final String USER_ID = "userId";
		
		public static final String USER_NAME = "userName";
		
		public static final String PASSWORD = "password";

//		public static final String LEVEL = "level";

		public static final String POSITION = "position";
		
		public static final String IMEI = "IMEI";
		
		public static final String LAST_VISIT = "lastVisit";

		public static final String EMPLOYEE_ID = "employeeId";
		
		public static final String EMPLOYEE_NAME = "employeeName";

		public static final String PHONE = "phone";
		
		public static final String COUNTRY = "country";
		
		public static final String PROVINCE = "province";
		
		public static final String CITY = "city";
		
		public static final String  ADDRESS = "address";
		
		public static final String LEAD_ID = "leadId";
		
		public static final String REMARK = "remark";
		
		public static final String AUTH_CODE = "authCode";
		
		
	}
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface RoleColumns{
		
		public static final String ID = "_id";
		
		public static final String ROLE_ID = "roleId";
		
		public static final String ROLE_NAME = "roleName";
		
		public static final String PERMISSION_ID = "permissionId";
		
		public static final String USER_ID = "userId";
		
	}
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface PermissionColumns{
		
		public static final String ID = "_id";
		
		public static final String PERMISSION_ID = "permissionId";
		
		public static final String PERMISSION_NAME = "permissionName";
	}
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface CustomerColumns{
		
		public static final String ID = "_id";
		
		public static final String CUSTOMER_ID = "customerId";
		
		public static final String CUSTOMER_NAME = "customerName";
		
		public static final String HEAD_OFFICE = "headOffice";
		
		public static final String USER_ID = "userId";
	}
	

	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface StoreColumns {

		public static final String ID = "_id";
		
		public static final String STORE_ID = "storeId";

		public static final String STORE_NAME = "storeName";

		public static final String REGION = "region";

		public static final String SUBREGION = "subrigion";

		public static final String PROVINCE = "province";

		public static final String CITY = "city";

		public static final String DISTRICT = "district";

		public static final String STREET = "street";

		public static final String LONGITUDE = "longitude";

		public static final String LATITUDE = "latitude";
		
		public static final String MAP_ID = "mapId";

		public static final String ZIP_CODE = "zipCode";

		public static final String AREA_CODE = "areaCode";

		public static final String PHONE = "phone";

		public static final String USER_ID = "userID";
		
		public static final String OPEN_TIME = "openTime";
		
		public static final String CLOSE_TIME = "closeTime";
		
		public static final String STORE_AREA = "storeArea";
		
		public static final String CHECKOUT_NUMBER = "checkoutNum";
		
		public static final String CHECKOUT_NUMBER_OFT = "checkoutNumOft";
		
		public static final String STORE_TYPE = "storeType";
		
		public static final String CUSTOMER_ID = "customerId";
		
		public static final String PROCU_CENTERS_TYPE = "procuCentersType";
		
		public static final String AUTHENTICATED = "authenticated";
		
		/**
		 * 这里有问题
		 */
		public static final String TELEPHONE = "telephone";
		
		public static final String REMARK = "remark";
		
	}
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface ActivityColumns {

		public static final String ID = "_id";
		
		public static final String ACTIVITY_ID = "activityId";

		public static final String ACTIVITY_NAME = "activityName";

		public static final String START_TIME = "startTime";

		public static final String END_TIME = "endTime";

		public static final String DISPLAY_GUIDE_ID = "displayGuideId";

		public static final String STORE_ID = "storeId";

		public static final String SALER_NUMBER = "salerNumber";

		public static final String GOAL = "goal";
		
		public static final String REQUIRE = "requie";
		
		public static final String TYPE = "type";
		
		public static final String IMPORTANCE = "importance";
		
		public static final String REMARK = "remark";

	}
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface ActivityFeedbackColumns {
		
		public static final String ID = "_id";
		
		public static final String ACTIVITY_FEEDBACK_ID = "activityFeedbackId";
		
		public static final String SALER_STATUS = "salerStatus";
		
		public static final String PRODUCT_STATUS = "productStatus";
		
		public static final String MATERIAL_STATUS = "materialStatus";
		
		public static final String DISPLAY_STATUS = "displayStatus";
		
		public static final String STATUS = "status";
		
		public static final String LONGITUDE = "longitude";
		
		public static final String LATITUDE = "latitude";
		
		public static final String PHOTOED = "photoed";
		
		public static final String ACTIVITY_ID = "activityId";
	}
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface ContractColumns {

		public static final String ID = "_id";
		
		public static final String CONTRACT_ID = "contractId";

		public static final String CONTRACT_NAME = "contractName";

		public static final String DISPLAY_GUIDE_ID = "displayGuideId";

		public static final String TYPE = "type";

		public static final String START_TIME = "startTime";

		public static final String END_TIME = "endTime";

		public static final String CONTENT = "content";

		public static final String IMPORTANCE = "importance";

		public static final String STORE_ID = "storeId";
	}

	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface ContractFeedbackColumns {
		
		public static final String ID = "_id";
		
		public static final String CONTRACT_FEEDBACK_ID = "contractFeedbackId";
		
		public static final String STATUS = "status";
		
		public static final String LONGITUDE = "longitude";
		
		public static final String LATITUDE = "latitude";
		
		public static final String PHOTOED = "photoed";
		
		public static final String CONTRACT_ID = "contractId";
	}
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface VisitColumns {

		public static final String ID = "_id";

		public static final String TYPE = "type";

		public static final String TASK_ID = "taskId";

		public static final String START_TIME = "startTime";

		public static final String END_TIME = "endTime";

		public static final String STATE = "state";
	}
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface DisplayGuideColumns {

		public static final String ID = "_id";
		
		public static final String DISPLAY_GUIDE_ID = "displayGuideId";

		public static final String DISPLAY_GUIDE_NAME = "displayGuideName";

		public static final String STORE_TYPE = "storeType";
		
		public static final String INTRODUCE = "introduce";

		public static final String PROVINCE = "province";
		
		public static final String CITY = "city";
		
		public static final String CUSTOMER_ID = "customerId";
		
		public static final String CREATED_TIME = "createdTime";
		
		public static final String DEADLINE = "deadline";
		
		public static final String TYPE = "type";
		
		public static final String USER_ID = "userId";
		
		public static final String CONTENT = "content";

	}
	
	/**
	 * 数据表的列
	 * @author CaoRen
	 *
	 */
	public interface MarketVisitColumns{
		
		public static final String ID = "_id";
		
		public static final String MARKET_VISIT_ID = "marketVisitId";
		
		public static final String STORE_ID = "storeId";
		
		public static final String TYPE = "type";
		
		public static final String TASK_ID = "taskId";
		
		public static final String LOG = "log";
		
		public static final String CREATED_TIME = "createdTime";
		
		public static final String USER_ID = "userId";
	}
	
}
